![]() |
|
#1
|
||||
|
||||
![]() See 2 conditional formatting in columns A and E of the attached. |
#2
|
|||
|
|||
![]()
Hi, Thanks for this and I can see the conditional formatting and it does indeed work.
I am trying to understand the formula in order to learn how to do them better, no matter what cell I click in on the A Column, when I look at the formatting for that cell is says Rule =$E3>25% Applies to =$A$3:$A$12 I notice there isnt a $ to the left of the E under rule so does that mean the rule is looking always at column E but the number will change on each subsequent cell, so E4, E5, E6 etc, even though the conditional formatting on each cell only shows E3 |
#3
|
||||
|
||||
![]()
Yes it does.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
sazetts | Excel | 7 | 02-09-2017 10:52 AM |
![]() |
Saywarder | Excel | 1 | 04-20-2015 11:29 AM |
![]() |
Cosmo | Excel | 2 | 04-08-2013 12:12 PM |
Conditional Formatting Problem Excel 2007 | namedujour | Excel | 6 | 08-04-2011 10:52 AM |
![]() |
Scaffold | Excel | 2 | 05-01-2010 08:56 AM |