Formula

Occasional Visitor

Okey so if anyone knows how to use IF formula can you help me put this in IF format....

 

=TODAY()=c4  COLOR RED

=TODAY()>=c4 COLOR RED

=TODAY()>=c4 COLOR GREEN 

BUT IF THE CELL IS EMPTY DONT COLOR AT ALL.... So i someone understands me... dadadadadadadadadadadddadada.JPG

the formulas pretty much does better teaching than me.

 

so if deadline is empty the has a date in it follow up should glow yellow and if the follow up is empt

2 Replies

@JForce 


@JForce wrote:

 

=TODAY()>=c4 COLOR RED

=TODAY()>=c4 COLOR GREEN 


Huh?

your example doesn't match the image (and doesn't make sense) the formulas in the image also have cell references that are offset from the colors will be happening 2/4 rows above the cell it is checking (but I think you know that and it is intentional) you can use ISBLANK() to check if it is blank so =NOT(ISBLANK(C4))*(TODAY()>=C4)