Previous Topic Next Topic

Conditional Formatting Excel 2007

Closed
S.B.Dijkstra - Aug 21, 2009 at 09:59 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Aug 21, 2009 at 11:52 AM
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
Related:

1 response

Answer 1 / 1
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Aug 21, 2009 at 11:52 AM
If you want to get the whole column coloured use H$4
If you want to get the whole row coloured use $H4
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

5 responses