Forum Discussion
Conditional Formatting to give specific reference
A1 contains a value, B1 has conditional formatting that shades it amber if A1 is greater than 5 and red A1 is greater than 10. I can duplicate this in B2 by format painting so that it relates to valu...
Farngorn ,
Select you range or entire column B, select the rule which "Use a formula...", use formula =$A1>10 (for red), apply desired format
and apply
Same for another rule