Changing cell colour through % differnce
Closed
ginga ninja
-
20 May 2009 à 05:09
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 21 May 2009 à 02:35
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 21 May 2009 à 02:35
Related:
- Changing cell colour through % differnce
- Rj45 colour code - Guide
- How to change text colour html - Guide
- Sound card colour code - Guide
- Changing keyboard language shortcut - Guide
- Changing date format in excel - Guide
2 responses
Excelguru
Posts
261
Registration date
Saturday 11 April 2009
Status
Member
Last seen
21 June 2011
307
20 May 2009 à 07:34
20 May 2009 à 07:34
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 12 April 2009
Status
Member
Last seen
16 February 2010
166
21 May 2009 à 02:35
21 May 2009 à 02:35
Try this in conditional formatting box .........
=(G5-H5)/H5>0.45
=(G5-H5)/H5>0.45
