CONDITIONAL FORMAT - green bar formula will not let other co

[itr674]

I use formula =MOD(ROW()-9,1*2)+1<=1 as a conditional format in order to have rows of alternating color, but I can't get other conditions to work in the colored row??

When I set up a condition where the word "OVDUE" will turn red and bold it only works in the rows that are not colored--in the green rows in does not change???

[ This Message was edited by: em on 2002-04-11 13:37 ]

[ This Message was edited by: em on 2003-01-31 23:36 ]

[ This Message was edited by: em on 2003-02-01 00:01 ]

[kinkyparamour]

I was playing with conditional formating and useing the following was able to make my green cells turn red.

condition one

cell value is equal to E2 (holding cell)

format red

With overdue in E2 when I type overdue into my formated cells they turn red

condition two

cell value is between 1 to 1000

format green

My cells are green with any number between 1 and 1000

if I have a green cell and i type in overdue it now turns red.


Hope this helped.........

Denny

[Mark W.]

On 2002-04-11 13:37, em wrote:
I use formula =MOD(ROW()-9,1*2)+1<=1 as a conditional format in order to have rows of alternating color, but I can't get other conditions to work in the colored row??

When I set up a condition where the word "OVDUE" will turn red and bold it only works in the rows that are not colored--in the green rows in does not change???

[ This Message was edited by: em on 2002-04-11 13:37 ]

See the Excel Help Index topic for "Conditional formats are not applied correctly.".

[kinkyparamour]

Another thought..........

If you want only the text in the cell to turn red..........

format patterns to no fill, then text to red.

Now we have green cells for numbers and the word overdue is red on a white background..


Denny

[Jack in the UK]

hi im sure i have some code i developed that will hunt out some word ie RED and turn that to overdue... eh, other way arround and this is in one column so its a target address script, works well but go on me wick so i outed it, email me on JackintheUK and ill sent it to you but it will be tommorow or over the week end i am dreadful at remembering and i get a lot of emails i reply personally to everyone who takes the time to contact regardless, and all personal messages i also reply, just so you know bug me and ill do it promise.

also in return please can i request you do not so much me but all reader PLEASE post my codes so everyone can use it, only fair, sure you understand,.,,

thanks

Chris D again bug me at work mate cheers your a good friend, you know ill forget otherwise.