Excel 2010 Conditional Formatting 1

[PWD]

Good afternoon, this is driving me nuts. I'm trying to get Condtional Formatting to work but it refuses to do what I think I'm asking it to do.

For example in Cell J90 I have a formula "=SUM(K90:M90)/I90" and want to colour it according to the value in G90 but as this is a template underconstruction there may be instances in Column 'G' where there are no figures, only "TBA". So I'd been thinking of something along the lines of:

="AND($G90<>""TBA"",$J90<$G90)"

But it doesn't format J90 when J90 = 40% and G90 = 55%.

Does anyone have any ideas please?

Many thanks,
D€$

 

[combo]

You need formula:
=AND($G90<>"TBA",$J90<$G90)
You can also consider splitting this to two conditions, first with =($G90="TBA"), second with =($J90<$G90). Excel applies first conditional formatting that match criteria.


combo

 

[PWD]

Thanks for this, I was wondering about all the quote marks but I think that was what happened after I'd pasted the formula as "=IF(AND(....."

Stupid boy!

Yes, I only want formatting if there's not "TBA" AND $J90 < $G90.

Many thanks,
D€$