How to change an entire row using conditional formating
 

Hi..
I am trying to make the text of an entire row go a different colour (light
grey) when a specified cell is equal to a given value (in my case the letter
€˜Y)

I can easily do something similar using the €˜equal to condition in the
€˜Conditional Formatting functions, but this will only work on the one cell
and not an entire row..

Can anyone write me the function or correct Conditional Formatting for this
to work ..?

Thanks in advance ..J

Hi
- select your row (lets say row 1)
- goto the conditional format dialog
- choose 'formula is'
- enter something like
=$A1="Y"
- choose your format

--
Regards
Frank Kabel
Frankfurt, Germany

"John Edwards" <John schrieb im
Newsbeitrag ...
Hi..
I am trying to make the text of an entire row go a different colour
(light
grey) when a specified cell is equal to a given value (in my case the
letter
€˜Y)

I can easily do something similar using the €˜equal to condition in
the
€˜Conditional Formatting functions, but this will only work on the
one cell
and not an entire row..

Can anyone write me the function or correct Conditional Formatting
for this
to work ..?

Thanks in advance ..J

Something like this would do it:
=$B16=50

Where Row 16 is the row in question and B16 is the specified cell and 50 the
target value. Make sure you switch to Formula is.

tj

"John Edwards" wrote:

Hi..
I am trying to make the text of an entire row go a different colour (light
grey) when a specified cell is equal to a given value (in my case the letter
€˜Y)

I can easily do something similar using the €˜equal to condition in the
€˜Conditional Formatting functions, but this will only work on the one cell
and not an entire row..

Can anyone write me the function or correct Conditional Formatting for this
to work ..?

Thanks in advance ..J