Conditional Formatting Excel 2007 [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

I´m trying to get a whole column coloured, depending of the value in H$.
This with only the use of Conditional formatting (no visual basic), as i need to explain it to my employees.

I´m pretty close, but i can´t seem to get the whole row coloured.

Kind regards,
S.B.Dijkstra

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
If you want to get the whole column coloured use H$4
If you want to get the whole row coloured use $H4

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!