Just select the range you want to format including the cell already
conditionally formatted, invoke Conditional formatting again and press OK!
Regards,
Stefi
€žsike11 via OfficeKB.com€ť ezt Ă*rta:
Hi,
Hope you can help. I have created a formula to fill a cell with colour based
on the user input.
Eg. If cell= "R" then colour cell Red;
if cell = "A" then colour cell Gold;
If cell = "G" then colour cell Green
I hope to copy that for the whole spreadsheet, however, when I tried to copy
the format to my other cells it only took the format of the original cell.
Is there a way to solve this?
Regards,
Mary.
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200606/1