Conditional formatting & if criteria

[r_2]

Hi,

Need ur help on conditional formatting & if criteria:

I req if E F G H < D colured in Red. D= whole column as my data varies in each row, so need to set formatting against column D, but able to do for D3, where all data format accordingly D3.
requirement:
E3, F3, G3, H3< D3
E4, F4, G4, H4< D4

& continue for total sheet.

for if criteria in case E, F,G, H>=D is Achieved( All E F G H must be equal or > D) if not will reflect Not Achieved.

 

[Luke M]

CF formula is:
=E3>$D3
applied to range E3:H10

Your formula needs to change to:
=IF(D3<=MIN(E3:H3),"ACHIEVED","NOT ACHIEVED")

 

[p45cal]

If I've understood correctly formula should be:
=IF(AND(E3>=D3,F3>=D3,G3>=D3,H3>=D3),"ACHIEVED","NOT ACHIEVED")
For conditional formats, see attached.

ps. post posting and seeing Luke's formula; his is better.

 

[r_2]

CF formula is:
=E3>$D3
applied to range E3:H10

Your formula needs to change to:
=IF(D3<=MIN(E3:H3),"ACHIEVED","NOT ACHIEVED")

Thnx luke & p45cal for if response, but enable to get CF details, can u share the step from where i need to start.

 

[r_2]

whether i can apply this with < formula or i have to create new formula

 

[p45cal]

see attached

 

[r_2]

hi, unable to do that, it will be helpful if u mention the stepwise step.

 

[p45cal]

Select cells E3:H9 starting at E3 (this is important).
Conditional Formatting|Highlight Cell Rules|Less Than…
In the field enter:
=D$3
(or select D3 with the mouse, but make sure the $ symbols end up as above)
Choose you format, OK.

 

[Luke M]

Correction to p45cal's formula:
=$D3
column should be absolute, not the row.

 

[p45cal]

Correction to p45cal's formula:
=$D3
column should be absolute, not the row.

oops

 

[r_2]

thnx luke & p45cal