normal Changing a cells color and entering yes or no based on other cell value

More
3 weeks 5 days ago #2372 by Lewis-H
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.

Please Log in or Create an account to join the conversation.

More
1 month 1 week ago #2320 by RetMarine
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.

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun