Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
Want to add a conditional format where A1 shows up- If A1 is 20% less than or 20% greater than C1.
Cant figure it out, any help appreciated.
ta.
Simplest way is to set up a hidden cell that's true if your condition holds or false if not, then format based on that.
If you're in Excel 2007, under the Conditional Formatting menu there's a "Use a formula to determine which cells to format" option. You should be able to use an IF-AND statement to put your greater or lower than bits in and fire on from there.
Can you set conditional formating for Cell A1 where:
Condition 1. Cell Value is Greater than or equal to =$C$1*1.2
Condition 2. Cell value is Less than or equal to = $C$1*0.8
and for the fomat have it change the text colour or cell colour?