laura_pink
New Member
- Joined
- Aug 21, 2014
- Messages
- 30
- Office Version
- 365
- Platform
- Windows
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
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