Conditional Format issue

[forestview]

Hi All

I have a list of dates in B7:B26 and want to format based on whether there is an entry in M7:M26 (e.g. if no entry in M10 then B10 formatted) completely stumped with this one.

Thanks

[etaf]

formatted as what - colour ?

for 2007, 2010 or 2013 excel version
Conditional Formatting

Highlight applicable range >>

B7:B26


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:


=M7=""


Format… [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

[forestview]

Hi Etaf

Great response it worked.

The colour format is to fade out the date font grey.

Thanks

[etaf]

you are welcome , thanks for the rep