Many questions on conditional formatting, but (of course) none specific to the problem I am having. So, here goes a new thread.
Excel 2010
What I am looking for:
On sheet 3, in cell C58:
bold red font IF sheet 1, column A:A=sheet 3, A58 and IF sheet 1, column H:H>2
For clarification:
Sheet 1 is my report detail (run daily); column A is the report date, column H is a numerical value
Sheet 3 is my statistics information; column A is the report date, column C is a record count (how many records for that date)
I need to have the font in sheet 3, column C to be bold red if any of the numbers on sheet 1, column H is > 2, for that report date
The number of records (in the detail) for each date can vary, so I cannot have a constant cell reference for the formatting
I will need to copy this formatting all the way down column C, as the statistics are a running report, each line for the next days data summary
Thank you!
Bookmarks