Forum Discussion
CONDITIONAL FORMATTING - EXCLUDE/SKIP TEXT
OliverScheurich Thanks for replying. This would work, but I'm trying to ensure any row in the columns can be typed in with text, not just the first. Plus, when we type in those comments, we may need to manually color those as well. That condition would keep them white.
But it looks like it didn't work for me here. Maybe there's a conflict between conditions?
You are welcome. Isn't it possible to enter text in any row of the columns H and I?
For rule "cells contains blank value" there is no format set and the OR( rule is in quotation marks which might cause a problem. Maybe you can attach a file without sensitive data. This would simplify the task.
If you conditionally format cells containing text white (background color) you can manually format their font color as shown in the screenshot.
OliverScheurich I can enter text in any row; however, I want to have the rows with text remain white or unaffected by the conditions causing the cells with dates to change color. As of now, they change color to green even if there's just one letter typed in.
Okay, So I should try removing the quotes? And coloring the cells themselves is preferable to coloring the letters. I'll try attaching the file too.
Update: Looks like the xlsx/xlsb file types aren't supported here. Can't attach the file.
Attached is my sample file. Maybe this is helpful. As far as i know it isn't possible to manually format the background color of a cell if it's (background color is) already formatted by conditional formatting.
=OR(ISBLANK($H1),ISBLANK($I1))This is the rule for conditional formatting if a cell is blank. The chosen format is white. The rules have to be entered without quotation marks as shown in the screenshot. Otherwise they aren't recognised and don't work.