Condiitonal formatting with multiple colours for text based on an if statememt.

[david gabra]

Hi

In the excle. - tab:Testing_Main CELL E8 - there is text that updated automatically.

I am not sure if this is possble.

If the text states: "CONGRATULATIONS!!!!! - ALL CELLS ARE UPDATED" - can the text be green and if the text has any other text - it should be red.

if stateemnt cell AS14

Thanks

David.

 

[ETAF]

is it just AS14 that changes colour was not sure , as seemed a bit strange on the various cells

anyway - if just AS14 conditional formating colour - RED , GREEN

two rules

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
AS14 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=(ISNUMBER(SEARCH("congratulations",AS14,1)))

Format [Number, Font, Border, Fill] Format GREEN
choose the format you would like to apply when the condition is true
OK >> OK

and then

Highlight applicable range >>
AS14 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=NOT((ISNUMBER(SEARCH("congratulations",AS14,1))))

Format [Number, Font, Border, Fill] Format RED
choose the format you would like to apply when the condition is true
OK >> OK

but you could just format the cell RED and only have the 1 rule for GREEN

 

[david gabra]

thanks so much.. you are so kind

 

[ETAF]

you are welcome