conditional formatting a row

[mikeywhits]

hi guys,

I am trying to conditional format an entire row based on cell d1 having the word "closed" within it. I also want to carry this through accross the range of the spreadsheet this being a1 to d10.

I have selected formula is, then input =$d$1="closed", then highlighted the whole field though when doing this it will only do my formatting to all when d1 states closed and not individually.

Thanks,

Mike

 

[VoG]

Try

=$d1="closed"

 

[mikeywhits]

Just tried that and when d1=closed every row is formatted.

What i want is for only rows with closed to format.

I have an old spreadsheet with the =$d$1="closed" conditional formatting used and it works so dont know why this spreadsheet isnt.

Could it be something to do with highlighting a field, cell or area before clicking into the conditional formatting??

 

[VoG]

You need to select the entire area before entering the CF.

 

[mikeywhits]

Hi Vog,

Did that first then entered the formatting.

It seems that the only cell which triggers any formatting is d1, which when it states "closed", it formats every row

 

[VoG]

Note the formula carefully, $ before D but not before 1

Excel Workbook
	A	B	C	D
1				closed
2				open
3				closed
4				open
Sheet5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =$D1="closed"	Abc

 

[mikeywhits]

working now Vog, thanks for your help