Conditional Formating if A1 is 100 then B1 text is red

[Oceans]

Trying to formulate
Conditional Formating:
if A1 < 100 then B1 text is red in color, else text is Blue in color

however, B1 already has an if formula =IF(B1=100%,"Yes","No")


Hope there is a way

[FDibbins]

1. highlight the range you want to apply the conditional formatting to (A1 or A1:A100, whatever you need)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =A1<100 format text Red

Repeat 3&4 with =A1>=100 format text BLUE

Edit: on a side-note. Conditional Formatting is just that...formatting, so it's not an actual entry IN the cell, it kinda sits "on top" of the cell

[Oceans]

I am afraid to declare that it did not work for me.

I am attaching a copy of the Excel File.

[judgeh59]

Give this a shot....I changed the color scheme a bit

[FDibbins]

In post 1 you said <100, what you forgot to add was <100%

go back into CF and edelete the 2 rules you have in there and start again.
3. select new rule, select use formula
4. enter =D4<1

Then click the FORMAT button, click FONT, select the COLOR drop-down and select RED

Repeat this (new rule) and use =D4>=1 and then select the color to format it with

[Oceans]

Give this a shot....I changed the color scheme a bit

Excellent, but i was hoping that you can include the tutorial

[judgeh59]

Sorry, I'm bit confused?....tutorial?...

[Oceans]

Sorry, I'm bit confused?....tutorial?...

How did you get the colors to change ?

[Oceans]

In post 1 you said <100, what you forgot to add was <100%

go back into CF and edelete the 2 rules you have in there and start again.
3. select new rule, select use formula
4. enter =D4<1

Then click the FORMAT button, click FONT, select the COLOR drop-down and select RED

Repeat this (new rule) and use =D4>=1 and then select the color to format it with

Ok, Got it. My Bad. Thanks

[judgeh59]

no problem at all....glad we could help....

[judgeh59]

Reminder - Please set the Thread to Solved if we're done....thanks