PDA

View Full Version : Solved: fill up cell background colour



benong
08-16-2011, 10:21 PM
hi,

i would like to change the cell 1 background colour if i enter a date on cell 2.
how can i achieve that?

pls refer to attachment for details.

thanks.

MRichmond
08-17-2011, 12:14 AM
You should be able to achieve that with conditional formatting.

Ive just tested it using the "formula is" option in conditional formatting using the formula =IF(B$8=$A$9,1,0), copying along the row, and it seems to work for me.

give it a try

benong
08-17-2011, 12:52 AM
Dear MRichmond,
thanks! it works great!