View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neall Neall is offline
external usenet poster
 
Posts: 95
Default Highlight row if condition is met

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