Forum Discussion
Solved
Conditional Formatting the results of a Filter formula
I had this functioning, but it got deleted and for the life of me I cannot figure out how to replicate it! I have an Excel Worksheet CURRENT PROJECTS. In it I have two tabs "data" and "results". O...
Thanks. You'll have to include the Project Type column in the filter.
And the conditional formatting formula should refer to the column on the RESULTS sheet.
You can hide column E on the RESULTS sheet if you wish.
See the attached version.
Where does "YES" come into this?
- Good catch Hans. Sorry. I meant to say "ACTIVE".
Select the column that you want to color.
I'll assume that the active cell in the selection is in row 1.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=$G1="EXISTING"
Click Format...
Activate the Fill tab.
Select blue as highlight color.
Click OK, then click OK again.Repeat these steps, but with the formula
=$G1="NEW"
and yellow as highlight color.
- Great, Hans. Thank you. That works well for the static array, but if I change more of my data to ACTIVE status, and thereby extend the array, the formatting does not automatically apply. Is it possible to fix that?
