Previous Topic Next Topic

Excell Conditional Formatting

Closed
Rob37 - Dec 25, 2011 at 02:27 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 25, 2011 at 09:41 PM
Hello,

I have been using conditional formatting to make a cell change colors if a)greater than or b)less than, today's date; however, I don't know how to tell excell to leave everything as it is when there is no information logged in the reference cell.

A C D
1 Today()
2
3 DATE EVENT
4 1mar11 red
5 1Jun12 Green
6 Blank (still changes color)???

I want D6 to stay without formatting when C6 has no date in it. Thanks,

Rob

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 25, 2011 at 09:41 PM
select first cell (for e.g. A1)
in the conditional formatting first
the formula is
=and(A1>=today(),A1<>"")
then use color green
similar for the less then today

copy A1 down and pastespecial-format
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

5 responses