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
- Crimping colour code - Guide
- Changing phone number t mobile - Guide
- If cell contains date then return value ✓ - Office Software Forum
- Conditional formatting if cell contains text - Excel Forum
- Changing hotmail password - 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
165
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