Question about syntax for conditional formatting
The condition becomes true if cell $B$12 is not blank and the date in it is
earlier than today + 120 days.
--
Regards!
Stefi
€˛Cbeckwith€¯ ezt Ć*rta:
See below:
Can someone explain the following in simple language;
=AND($B$12<"",$B$12<TODAY()+120)
What does the < after the cell location mean? and why the double quotes ""?
I thought the double quotes meant whatever is in the cell is NULL....I have a
date in the $B$12 position.
|