0
Undo
Votes
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.
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.
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.