Changing cell colour through % differnce
Closed
ginga ninja
-
May 20, 2009 at 05:09 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 21, 2009 at 02:35 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 21, 2009 at 02:35 AM
Related:
- Changing cell colour through % differnce
- Rj45 colour code - Guide
- Cell colour formula in excel - Guide
- Changing cortana's search engine - Guide
- Cell phone codes - Guide
- Sound card colour code - Guide
2 responses
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
May 20, 2009 at 07:34 AM
May 20, 2009 at 07:34 AM
Hi
Do conditional formatting
Select A5 select ' conditional formatting from Format menu
use the formula =g5-H5>0.45
Give the format you need
Do let me know If it helps...
Do conditional formatting
Select A5 select ' conditional formatting from Format menu
use the formula =g5-H5>0.45
Give the format you need
Do let me know If it helps...
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
May 21, 2009 at 02:35 AM
May 21, 2009 at 02:35 AM
Try this in conditional formatting box .........
=(G5-H5)/H5>0.45
=(G5-H5)/H5>0.45
