• New Patreon Tier and Early Access Content available. If you would like to support AVForums, we now have a new Patreon Tier which gives you access to selected news, reviews and articles before they are available to the public. Read more.

excel formula help

njdbaxter

Prominent Member
i have 2 columns

one is a closure due date, second is closure date

in the first column, closure due date, I want cell to fill in YELLOW if date within 30 dates, and fill in RED if date has past, which i have been able to do.

now i want the cell to fill in white if the item has been closed, if closed, closure date would be in column 2. so if date closed field is filled in, the closed due date field is filled in white.

i just cant get the third formula correct.

what would it be?

=NOT(ISBLANK( )=TRUE) cant get it right
 
Last edited:

pSeudo

Established Member
Would it not just be '=Column2<>"" ' then white (as in, if column2 does not equal ('<>') blank ("") then white
 

Woodsie

Prominent Member
The attached works from what I understood.
Formulas in conditional formatting:

White
=NOT(ISBLANK(B2))

Red
=A2<NOW()

Yellow
=A2<NOW()+30
 

Attachments

  • CONDITIONALFORMAT.jpg
    CONDITIONALFORMAT.jpg
    88.7 KB · Views: 69

The latest video from AVForums

Is 8K TV dead? Philips OLED+907, Pioneer LX505 AVR plus B&W 700 S3 Reviews & Visit + AV/HiFi News
Subscribe to our YouTube channel
Support AVForums with Patreon

Top Bottom