Conditional formatting formula required for day of week and a value

[laura_pink]

Hi,
I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of the week i.e. "Mon".
I need to set some conditional formatting so that when column C is "Mon" and column B is greater than 415, then the value in column B turns red.

I have tried this and its not working:
=AND($C$3:$C$2734="Mon",$B$3:$B$2734>415) I have also tried it the other way round =AND($B$3:$B$2734>415,$C$3:$C$2734="Mon")
I have also tried it without the commas around Mon - nothing works.

Any ideas? Many Thanks,
Laura

 

[Fluff]

How about

 =AND($C3="Mon",$B3>415)

 

[laura_pink]

Didn't work I'm afraid. It turned some Saturdays red instead??
Thanks for the suggestion.

 

[Fluff]

Is row 3 the first row of data?
Also what is the applies to range?

 

[laura_pink]

Yes row 3 is the first line and it runs from 3 to 2734

 

[Fluff]

What is the applies to range?

 

[laura_pink]

Everything runs from A3 to C2734 - sorry not sure what you mean I am a novice

 

[Fluff]

If you click on Conditional formatting, Manage Rules you will see something like

What does it say in the applies to box ( in the above case =$C$1:$I$27)

 

[laura_pink]

=$C:$C
ALSO TRIED
=$B:$C

 

[Joe4]

When you write a CF formula for a multiple cell range, you need to write it as it pertains to the FIRST cell in that range.
So if you are choosing all of columns B and/or C, you need to write the formula for row 1, i..e

=AND($C1="Mon",$B1>415)