Block colour a cell

[Guest]

i want to apply this to a cell, i dont know if it can be done

if column O1:O370>4 and column L1:L370>11 I want cell AH to turn bright yellow

 

[J.E. McGimpsey]

If I understand you correctly, you mean that you want to color cell
AH1 yellow if both O1 > 4 and L1 > 4, and likewise for each
subsequent row down to AH370. If so, select AH1:AH370 (with AH1 the
active cell) and choose Format/Conditional Formatting... Then use
the dropdowns and textbox to enter

Formula Is =AND(O1>4,L1>11)

click Format, and choose bright yellow from the Patterns tab. Click
OK, OK.

XL will adjust the row references for AH2:AH370.

 

[jturner2172]

Probably need to use an extra column to put a value of one in the column if
both are values are true, then use conditional formatting to fill in cell
(maybe change text color as well??)

This would be the non VB way to do it

i want to apply this to a cell, i dont know if it can be done

if column O1:O370>4 and column L1:L370>11 I want cell AH to turn bright

yellow