Thread: Conditional Formatting multiple cells

If I have column b that contains a 'X' and i have column d that contains a date. How can get the all X's in column B, thru row 300, to show red if no date exists in the corresponding date column

do i have to set the conditional formatting for each cell in column B?

thanks

Starting with cell B1, highlight cells B1:B300. Then use the following formula in conditional formatting:

=AND(B1="X",D1="")

HTH

Jason