Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Saturday, 04 July 2020
  1 Replies
  4.9K Visits
0
Votes
Undo
How can I change the color of an excel cell to either red or green and have that same cell auto fill with yes or no based on another cell with a value less than or greater than zero.  Thanks for assistance if possible.
3 years ago
·
#2158
0
Votes
Undo
No code required.

Select cells C15 to N15
click Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format
enter this formula
=$M15="yes"

select a format, for example green fill and close all dialogs
keep the cells selected and enter another rule with the formula
=$M15="no"

select a format, for example a red fill and close all dialogs.
You can now copy the cells and use Paste special > Formats to copy the conditional formatting to other rows.
  • Page :
  • 1
There are no replies made for this post yet.