Forum Discussion

jjmthena2025's avatar
jjmthena2025
Copper Contributor
Jan 20, 2023

CONDITIONAL FORMATTING - EXCLUDE/SKIP TEXT

Hey all,   Hope this issue isn't too complicated. I have a worksheet that lists dates with rules that highlight them in various colors depending on how far away or past they are from today's date. ...
admin
excel
Formulas and Functions
training
jjmthena2025's avatar
jjmthena2025
Copper Contributor
Jan 20, 2023

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.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jan 20, 2023

jjmthena2025 

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.