G
Guest
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
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