Forum Discussion
Kailef
Mar 31, 2023Copper Contributor
Need help with Highlight with Conditional Formatting
Using Excel 365. I have this data pulling from a query. This data will change daily. It's giving me a count of certain data based on the date of entry. I need it to highlight based one of two conditi...
NikolinoDE
Mar 31, 2023Platinum Contributor
Yes, it is possible to combine the two conditions into one rule for each column using the OR function. You can use a formula like =OR($D1>1, AND($D1>=1,$D2>=1)) for the first column and then adjust the cell references for each subsequent column.
This formula checks if the value in cell D1 is greater than 1 (first condition) or if both cells D1 and D2 have values greater than or equal to 1 (second condition).
You can then apply this rule to the entire column using the Format Painter or by selecting the entire column and creating a new conditional formatting rule.
I hope this helps!