Wed 24 Nov 2010, 16:23Delegate Richard said...
Richard has attended:
Excel Intermediate course
Excel Advanced course
Conditional Formatting
How to set the above when
50% (100/200) is in the cell and you only want the colour to change in another cell by reading the %, i.e. the 50% being the main figure against the target of 100%.
Mon 29 Nov 2010, 10:25Trainer Simon said...
RE: Conditional Formatting
Hi Richard,
Thank you for your question.
Click into the relevant cell and go to Format and then Conditional Formatting.
Choose Formula is and enter = followed by the cell reference containing the % amount. Follow that by an equals sign and finally enter the value you want the cell to be tested against.
e.g. Formula is =c2=50%
I hope this answers your question.
Regards
Simon
