View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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