conditionnal formatting

[chip666]

i have a special conditionnal formatting to do
first of all, i have to check a date in column D
if that date is today or before then highlight the whole line (from A to L) in red
then (i got this one on your board already) if cell L = "x" then highlight the whole line yellow.

second condition (yellow) disable first condition (red)

Thank for the help

 

[NBVC]

Highlight cells A:L and all rows to consider, and select FORMAT|Conditional Formatting

Set 1st condition to Formula Is =$L1="x" and choose Yellow

Set 2nd condition to Formaula Is =$D1<=Today() and choose Red

 

[chip666]

excellent

that helped me a lot, but what if there is nothing typed in column B and i dont what that line to be highlight

in other word, if a line have nothing in column B, i dont want conditionnal formatting on that line

Thanks again

 

[NBVC]

Change the formatting formulas as follows.

Set 1st condition to Formula Is =And($L1="x",$B1<>"") and choose Yellow

Set 2nd condition to Formaula Is =And($D1<=Today(),$B1<>"") and choose Red