Now I understand! Omit $s from your formulae!
Stefi
€žsike11 via OfficeKB.com€ť ezt Ă*rta:
May be I should clarifiy what is the formula. Please see below:
Formula is =$D$5 : $I$28 = "G" then format is colour Green
Formula is =$D$5 : $I$28 = "A" then format is colour Gold
Formula is =$D$5 : $I$28 = "R" then format is colour Red
This only seems to work for the first cell (which happens to be "G"). It then
colours all the specified range Green.
Any ideas?
Mary.
sike11 wrote:
No, not the entire worksheet - only about 6 coloumns.
Hi Mary,
[quoted text clipped - 11 lines]
Mary.
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200606/1