I want for cells A3-S3 to highlight yellow if cell a3 has an "x" and highlight red if cell b3 has an "x"
garbo7441 can I ask for additional help, if I wanted this rule to run all the way through cells 100 how would I alter this formula. I have tried format painting and it does not work
- garbo7441Lv 71 month agoFavorite Answer
You don't state what you wish to do with A3:S3 if BOTH A3 and B3 have an 'x'. So, these rules will simply not format any fill color if that condition exists.
In the Home tab, select Conditional Formatting and click 'New Rule'
Select 'Use a formula to determine which cells to format'.
In the 'Format values where this formula is true' textbox, enter this formula:
Click 'Format', select the Fill tab, select the Red option, and click 'OK' twice.
Repeat the above process, except using this formula and selecting the Yellow option:
- ∅Lv 71 month ago
you need to set 2 conditionals for that. one for red, one for yellow.
- ALv 71 month ago
go to the home tab and use conditional formatting, set up the rules to do what you need