katkth7533
New member
- Joined
- Jul 29, 2014
- Messages
- 17
- Reaction score
- 0
- Points
- 0
Hi everyone! I was hoping that someone could help me with a formula. I am drawing a blank. In Excel, I want to do conditional formatting on a cell based on the value of another cell. For example: in cell A1, I have text. I want this cell to have a grey background if the value of cell B1 is less than or equal to 1/31/14. How would I do this? Any suggestions? Thank you for your help!