Hi Kassie.
That works except when I enter condition2: cell value = 4% the result is no
color; when I copy that format to a cell that contains 1,000,000 it changes
it to a percentage.
This is what I have:
Spreadsheet for our subcontractor & their insurance coverage amounts and
expiration dates. When an amount is entered that is under the required
500,000 I need the cell to highlight green. When 4% is entered I do not want
anything to happen to that specific cell. When n/a is entered I do not want
anything to happen to that cell either.
When I write a conditional format:
cond1 - cell value is between 1 and 499,000; color the cell green
cond2 - cell value is equal to 4%; no color
When I copy this to a cell that contains 1,000,000 or any other number, it
changes it to a percentage.
Thanks for any help.


"kassie" wrote:

Will it work for you to set your cell value to between 1 and 500 000, for a
green colour?
Otherwise, you may require more than one condition.
If only 4% should not colour, but 3% or 20% should colour, then look at Cell
Value between 0 and .39 as first conditional format, with pattern as green.
Click on Add, select cell value between, set it to between .41 and 500000,
again with the colour format.
--
Hth

Kassie Kasselman


"Jenn" wrote:

Yes, that's funny.
Still need help with the formula though.


"Jason Lepack" wrote:


Bernard Liengme wrote:
book - forgive the four-lettered word.

LOL!

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jenn" wrote in message
...
I need to create a conditional formula that says:
If cell is < 500,000 color the cell bright green
If cell contains "n/a" or "4%" do not change format
I've tried entering them each as a condition but that's obviously not
working.

I need major help with formulas.
Can anyone refer me someplace where I can get help with learning to create
formulas?
Thanks a bunch!