Forum Discussion
CONDITIONAL FORMATTING - EXCLUDE/SKIP TEXT
=OR(ISTEXT($H1),ISTEXT($I1))You can try this rule for conditional formatting. Instead of "No format set" i've selected format white color.
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.
