Condtional formatting in Excel

  • Thread starter Thread starter Eán
  • Start date Start date
E

Eán

If I have for example the formula:
Formula is =IF(F9-1<=$E$6+3,1) which will turn my cell red, is there anyway
I can turn it red and mark it with the number 1 and then 2 for amber, 3 for
green etc?
 
You can use =IF(F9-1<=$E$6+3,1) as your formula in the cell (but preferably
also include a defined output for when the condition isn't met, rather than
letting it default to FALSE), and use =(F9-1<=$E$6+3) in the Formula Is
condition in conditional formatting. You will have realised, I hope, that
=(F9-1<=$E$6+3) is the same as =(F9<=$E$6+4) or =(F9-4<=$E$6)?

If you want further conditions, expand your cell formula alonmg the lines of
=IF(F9-1<=$E$6+3,1,IF(condition2,output2,IF(condition2,output3,output_if_condition3_not_met))),and in conditional formatting after specifying the first condition and itsformatting, use "Add" to include a second and third condition and theirrespective formats.--David Biddulph"Eán" <[email protected]> wrote in messageIf I have for example the formula:> Formula is =IF(F9-1<=$E$6+3,1) which will turn my cell red, is thereanyway> I can turn it red and mark it with the number 1 and then 2 for amber, 3for> green etc?
 
Back
Top