zepold
asked on
How do I set the background color of a cell based on the values in a range of cells?
How do I set the background color of a cell based on the values in a range of cells? I have a spreadsheet with columns that have static data and a range of columns that has dynamic data. I want the rows of static data to be highlighted if the data in that range is equal to a specific value.
For example, if the data in range D3:O3 all equal "OFFLINE", then I want row A3:C3 to be highlighted in red.
Sample.xlsx
For example, if the data in range D3:O3 all equal "OFFLINE", then I want row A3:C3 to be highlighted in red.
Sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
=(COUNTIF($D3:$O3,"=OFFLIN
Seems to work, as well, but I haven't tested it fully. Literally, just came up with it when I got your email.