CONDITIONAL FORMATTING QUERY


Joined
Jan 14, 2015
Messages
1
Reaction score
0
I have looked through various postings but cannot find an answer to my query (probably here somewhere already).

Can someone please help me out? I want to conditionally format the fill of a Cell (A1) based on info in another cell (B1), something like:
If todays date is later than the date in Cell B1, and Cell A1 contains a number less than 100, turn the cell red, but if it does say 100, turn it green.

Probably quite simple to do but I am a complete novice at this and would appreciate any help. I have tried various things but end up getting lost.

Many thanks
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top