Formula for change background according to data
PERFECT
thank you
"Luke M" wrote:
Copy the cell that has the conditional format, select the area/rows you want
the formatting applied. Right-click, special paste, format only.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"shallowz" wrote:
that worked thank you very much
now i have another question
what if i want to use the same number but i want to place them in multiple
rows
like row 18-24?
"Luke M" wrote:
assuming cell A2
Go to Format-Conditional Format
Cell formula is:
=OR(A2=5,A2=15,A2=25,A2=30)
Then go to format and set pattern to whatever color you want.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"shallowz" wrote:
i have excel 2007
i want to set up a rule or a setting or something so that when a cell gets a
set of numbers it will change the color of the cell to green example
in the cell i want to add 5, 15, 25, 30 etc
and any time a 5 or a 15 or a 25 or a 30 is typed into that cell it will
chance the cell to green.
is there any way of doing this?
|