Conditional formatting

[Jvic28]

Hi,

Another question for you this morning.

I want to highlight a range of cells a particular colour once any date is entered in a specific cell.

How? Stumped.

[veejar]

can upload a sample file if possible

[Jvic28]

http://http://spreadsheets.google.co...5kbFE&hl=en_GB

Are you able to use this link.

What I want is for A2:C2 to be highlighted when a date is entered in C2.

Thanks

[veejar]

well i am unable to access the link

but check this thread and download the file if required
http://www.excelforum.com/excel-gene...-in-excel.html

[Jvic28]

Try this one.

[Jvic28]

What I want is for A2:C2 to be highlighted when a date is entered in C2.

[veejar]

Please see the attached sheet

[Jvic28]

This doesn't seem to work though as when i take the date out of C3 the row remains highlighted.

[veejar]

well buddy is the date being entered in C2 or C3
I have assumed C2 as mentioned in your previous post

[Jvic28]

I'm easily confused, sorry. I meant C2. When I take the date out of C2 it remains highlighted.

[veejar]

ok cool,

Just try deleting values in C2 in my sheet. It should not highlight A2:C2.
If there is any value in C2 then A2:C2 will be highlighted in yellow

[Jvic28]

Ok. I think I got it. Say i want to add more rows then, how can i quickly change the formatting to apply to each row. ie highlight row 3, 4, 5, etc when dates are entered in C3, C4 and C5. Sorry, I'm really a newbie at this excel lark.

[veejar]

well no issues

Please check the attached file.

If you need to copy to further cells then simply select format painter icon and click on the cell that has conditional formatting and then select the cells to which you want the format to be extended to.

[Jvic28]

I was just about to write to say I just can't get it, but at the last miute, I got it.

Thanks for the help. Really useful.