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

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