conditional formatting

[mariusescu]

I'm looking to a way to format the entire row in a table based on a specific value in one of the cells in that row.
To be more specific, let's say I have a table A1:F5. If the value in cell C3 is 5, the entire row C in the table (C1:C5) should be turned green.
Any help is very appreciated

Thx
Mariusescu

[martindwilson]

highlite cells in row
format/conditional format
use
formula is =$C$3=5
select format/patterns choose cell colour

[mariusescu]

Thanks a lot Martin.
Mariusescu

[martindwilson]

no problem