I need to write have cells highlight with a specific colour based on the following but I'm completely stumped on how to write it:
Cell F3 to be conditional formatted to do the following:
- Green fill if more than J3
- Orange fill if 10% less than J3
- Red fil if more than 10% less than J3
The first one I can get, but the last two have me really stumped. Help!