View Single Post
 
Old 11-06-2014, 06:19 AM
JaxV JaxV is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Nov 2014
Posts: 8
JaxV is on a distinguished road
Default

I think I may have a solution for the 2nd issue, but need some help still (anyone? )

I have set a conditional format to change the cell colour depending on the option selected from the drop down box (employment status). I would then like to auto copy the formatting (not the text) to the row where number of visits is entered. This way, I can then set it to count only the numbers with a specific format.

So...how can I set conditional formatting to format a row of cells based on a different cells text?

Thanks in advance, i'm sure there is someone with the answer
Reply With Quote