View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cbeckwith Cbeckwith is offline
external usenet poster
 
Posts: 5
Default Question about syntax for conditional formatting

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.