Patrick O'Dea
asked on
Simple Conditional Formatting (Traffic Lights!)
Hi,
See attachments which should be clear.
Simple enough conditional formatting which I can't get to work.
If Sales!B2 < TrafficLights!$C$2 then Sales!B2 should be Orange
If Sales!B2 < TrafficLights!$B$2 then Sales!B2 should be Red
This logic should apply to columns B to E in Sales Spreadsheet
Thanks for your time!
TrafficLights.xlsm
See attachments which should be clear.
Simple enough conditional formatting which I can't get to work.
If Sales!B2 < TrafficLights!$C$2 then Sales!B2 should be Orange
If Sales!B2 < TrafficLights!$B$2 then Sales!B2 should be Red
This logic should apply to columns B to E in Sales Spreadsheet
Thanks for your time!
TrafficLights.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I tried with the "Stop If True" box being ticked after first condition but didn't seem to be working for some reason, hence why I went for the less than one value for condition 1 and between two values for condition 2; indeed the second should have the >= rather than just >.
Thanks
Rob
Thanks
Rob
ASKER
Great stuff!
In my solution the CF Red is before the CF Orange and I use Stop if True to avoid being Orange
with equivalent formulas to
Red:B2 < TrafficLights!$B2
Orange: B2 < TrafficLights!$C2
@RobHenson
Shouldn't your formula for Orange be
=AND(B2>=TrafficLights!$B2,B2<Traff
Regards