Formula

[JForce]

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... 

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]

@JForce 

---

@JForce wrote:

=TODAY()>=c4 COLOR RED

=TODAY()>=c4 COLOR GREEN 

---

Huh?

[#3]

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)