Conditional formatting of rows and columns?

[GBL]

Hi:
Does anyone know if colors of rows or columns can be controlled via
conditional formatting?? If so, how?

 

[Sweede]

Go to Format | Conditional formating..

Chose Cellvalue or formula set formating to be used if expression it true, this could be collo

Sweed

 

[GBL]

Sweede:
Let me be a little more specific.
I'd like to change an *entire* row color using conditional formatting when
the condition of one worksheet cell meets a formula condition. Let's say,
if A1 is greater than 3 how do I change the another entire row (say row 6)
to red?

 

[Frank Kabel]

Hi
try the following:
- select row 6
- goto 'Format - Conditional Format'
- choose 'Formula' and enter the following formula
=$A$1>3
- choose your format