Previous Topic Next Topic

Conditional Formatting Excel 2007

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

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

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
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response