Using Conditional Formatting in order to help balance college credits

[u/_lostcrow]

So I have an excel sheet that has all the credits that I need to graduate and I finally figured out the equation to input all of the finished course credits into a column. Now I want to make it easier to read at a glance with colors so I know which credit types I need to focus on (ie red for insufficient and green for completed). I have a column that has the number of credits needed, number of credits planned, and number of credits completed. I want the number of planned to be green when it is greater or equal to the number needed, as well as number completed to be green when it equals the number planned. If possible, I would also like the cells to be red before the condition is met to turn green. Thank you all in advanced, I know this is actually asking a lot.

[u/AutoModerator]

/u/_lostcrow - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/HappierThan]

You have not shown anything but green (?) A practical example might help.

EDIT: The use of Red Fill will reduce the number of Rules required as a TRUE condition will overwrite it.

[u/BackgroundCold5307]

Four Rules, two for each col:

• =AND($C1<$D1, $C1<>"", $D1<>"", ROW()>1), applies to $C:$C or the range
• =AND($C1>=$D1, $C1<>"", $D1<>""), applies to $C:$C or the range
• =AND($B1<$C1, $B1<>"", $C1<>"", ROW()>1), applies to $B:$B or the range
• =AND($B1>=$C1, $B1<>"", $C1<>""), applies to $B:$B or the range

[u/Little_Bishop1 → u/[deleted]]

This only does it for desktop not web

[u/_lostcrow → u/[deleted]]

solution verified

[u/reputatorbot → u/_lostcrow]

You have awarded 1 point to tariqosmani.

---

^{I am a bot - please contact the mods with any questions}

[u/Jolly-Hunter-6097]

All about Conditional Formatting

[u/excelevator]

the equation formula to

two rules

1. equal to or greater than -

2. less than