Select the range to format ( D3:AA3,say)
Open CF wizard
New rule enter =D$2=0
Format as needed
Done
( the $ sign before the row number is important)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|