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
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