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 GarciaApr 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.
- Katie GarciaApr 05, 2018Copper Contributor
After a slight tweak for my document's specifics, this works great. Thank you so much!