Conditional Fotmatting based on several columns!

[ahhhmed]

Hi all,

I have this spreadsheet: A1:U20

I want to conditionally format the cells in column A when the cells in column ( I ) OR the cells in column ( M ) OR the cells in column ( Q ) or the cells in column ( U ) are less than 60.

Can you please help me write a suitable formula?

Thanks

 

[Sachin]

Select A1:A120

Open conditional formatting

Select New Rule

Select Use a formula to determine which cells to format

In the formula window enter this formula:


=OR($I1>60,$M1>60,$Q1>60,$U1>60)


then select the format you want below.


Good luck.

 

[ahhhmed]

Thank you sir