I am trying to conditionally format an entire row in Excel 2007. This used to be easy in 2003, but I cannot make it work in 2007. I am trying to change the color of an entire row based on the value of a cell in that row. My formatting formula looks like this:
Formula: =C6:C44="city name” applies to =$A$6:$D$44
This formula only changes the color of cells A6:A44 when C# is true. Columns B, C and D do not change.
Can one of you experts answer this and maybe even make it into an FAQ? There is not much on Tek Tips about this that I could find.
Please don't tell me about VBA. This is an Excel question in the MS Office forum.
Formula: =C6:C44="city name” applies to =$A$6:$D$44
This formula only changes the color of cells A6:A44 when C# is true. Columns B, C and D do not change.
Can one of you experts answer this and maybe even make it into an FAQ? There is not much on Tek Tips about this that I could find.
Please don't tell me about VBA. This is an Excel question in the MS Office forum.