Lets say I have a name in cell A1. I'd like to make that cell green if there is "o" or "x" in any of the cells spanning B1:Z1.
Also, could you do this thing on a larger scale if you have 20 names under column A from A1:A20; so you don't need to format each cell individually?
Here is an example of my naughty and nice list:
A B C D
Name Mon Tue Wed
Mark x x
Donna o x o
Amy x
I tried to do it with conditional formatting on A2
=OR($B$2:$H$2="x";$B$2:$H$2="o")
but in this instance it only works on the first two examples, since the B column has a value in it. Is it possible to do that on a list of 40 people on a mass scale. to not have to do formatting for each row seperately?
I'm using Excel 2013 if that helps in any way.
I would do what you have (the OR expression,
=OR(NOT(ISBLANK(Table2[@[B]:[D]]))) (as an array, shift-+ctrl+enter)
) and put it in it's own column(E). Then just look at that with a formula in the conditional formatting that looks like:
=E2
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments