Conditional Formatting

[Helen Wills]

Hi

I am trying to conditional format a cell but am struggling

I have a summary sheet, which I would like to autopopulate based on data on other sheets in the workbook

I would like Cells A15 and B15 on Sheet A to conditonal format to green, if the there is no data in column M on Sheet B. In column M I will manually place a # next to records I have identified as incorrect.

If all cells are blank in Column M is blank in Sheet B, I would like Cells A15 and B15 on Sheet A to conditonal format to green

Is this possible?

Thanks All

Helen

 

[etaf]

use a conditional formatting formula

Select cells A15 and Cell B15

=COUNTA('Sheet B'!$M:$M)=0

for 2007 or 2010 excel version
Conditional Formatting


Highlight applicable range >>
A15 and B15


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:


=COUNTA('Sheet B'!$M:$M)=0


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