Forum Discussion
Katie Garcia
Mar 30, 2018Copper Contributor
Conditional Formatting - formula including cells with formulas
Hi,
I'm trying to create conditional formatting of cells and need help to confirm the details.
In my spreadsheet, Columns look like this:
Column E Column F ...
- Mar 30, 2018
Please see the setup in the attached workbook.
Jamil
Mar 30, 2018Bronze Contributor
Please see the setup in the attached workbook.
Katie Garcia
Apr 05, 2018Copper Contributor
Follow up question:
How do I adjust the formulas for two different fills, based on a letter code in another column?
In the attached workbook, I'd like lines with code "V" to fill Column 3 blue or green font (based on the previous rules) with a teal background. Lines with code "C" would fill Column 3 with blue or green font but with a white background.