All Questions
4
questions
0
votes
1
answer
31
views
How to use conditional formatting based on a different column?
Looking to format a column background color using conditional formatting based on the integer value from a different column. Where or how is the second column referenced?
Bing AI, copilot, says:
...
1
vote
1
answer
66
views
Excel conditional formatting highlighting different cells in range
I need to setup conditional formatting to highlight any cells in the range that are not equal to the first cell. I have attached 2 pictures the first is how the data is typically entered and I have ...
1
vote
2
answers
1k
views
Highlight rows with identical data in Excel
I have a number of rows within a large spreadsheet that have some identical rows I would like those rows highlighted but only if every cell on the row matches, if random cells from different rows ...
1
vote
2
answers
779
views
Highlighting Groups of Alternating Names in Excel
I have been trying to find a good way to do this but it seems like I can not find a good Conditional Formatting formula to work with what I need. I am trying to do something along the lines of this ...