Forum Discussion
Solved
Conditional Formatting based on formula
Hi everyone, I hope you can help this novice Excel user. 🙂 I'm using Office Home and Business 2019 on a Windows 10 PC. I have cells with three kinds of formulas in it: =AK3 =SUM(AK3...
- The easiest way to do this would be to compare the cell value to the AK3 value as your conditional formatting formula. I'm sure they aren't all literally =AK3 but if you are looking at conditional formatting of column AM and AM3 might be one of those 3 options and AM4 would be one of those options but using AK4 and so on down the column then:
Select column AM
Create new rule
Select custom formula option
use =AM1<>AK1 (note if you select only a range in column AM like AM3:AM100 then you must use the first cell accordingly like =AM3<>AK3)
The easiest way to do this would be to compare the cell value to the AK3 value as your conditional formatting formula. I'm sure they aren't all literally =AK3 but if you are looking at conditional formatting of column AM and AM3 might be one of those 3 options and AM4 would be one of those options but using AK4 and so on down the column then:
Select column AM
Create new rule
Select custom formula option
use =AM1<>AK1 (note if you select only a range in column AM like AM3:AM100 then you must use the first cell accordingly like =AM3<>AK3)
Select column AM
Create new rule
Select custom formula option
use =AM1<>AK1 (note if you select only a range in column AM like AM3:AM100 then you must use the first cell accordingly like =AM3<>AK3)