Highlight row if condition is met
Maybe conditional formatting:-
Select all cells by cliking the block above the 1 of row 1 and then
Format|Conditional format
Formula is
and enter the formula =$X1=30
and choose you colour.
Mike
"Neall" wrote:
Good day all;
I am not sure if conditional formatting can do this but I want to select my
entire sheet and state that;
IF any cell in Column X is =30 then highlight corresponding Row (yellow)
Can this be done?
Thanks in advance
--
Neall
|