•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Changing a cell colour based on if 2 cells do/dont match
Our take
In this task board scenario, you can easily set up conditional formatting to change a cell's color based on whether two values match. Specifically, if the “tasks in” number equals the “tasks out” number, the “to do” cell can turn green; otherwise, it will appear red. This visual cue not only enhances clarity but also improves your overall productivity by allowing for quick assessments of task alignment. Let's explore how to implement this effective solution for better task management.
Hi guys, so im putting together a task board and would like to know if/how i can get a cell to turn red/green based on if the “tasks in” number matches the “tasks out” number
So for example, if “in” equals 3 and “out” equals 3 the “to do” cell will be green, if not it will be red
Any help would be appreciated, thanks
[link] [comments]
Read on the original site
Open the publisher's page for the full experience