• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 43
  • Last Modified:

Excel Conditional Formatting

In a spread sheet I would like conditional formatting for the following.

In a row....all boxes are blank right now
If something gets inputted into the 2nd, 3rd, 4th, or 5th box, (B, C, D, E) i want the first box (A) to show todays date and be highlighted in red.

Can anyone assist me in doing this

Thanks
0
Mike
Asked:
Mike
1 Solution
 
Rob HensonFinance AnalystCommented:
Conditional formatting cannot add contents to the cell but it can adjust the formatting.

it would be possible to have a formula in column A that was blank until cells B, C, D or E are populated but that would recalculate each time the sheet recalculates, a date would therefore update on the following days.

Formula:

=IF(COUNT(B2:E2)>0,TODAY(),"")

To have the date entered as a result of entering in other columns would require VBA.

Alternatively, there is a very quick keyboard shortcut for entering the current date, press "Ctrl + ;" and Enter.

Thanks
Rob H
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now