changing cell background colors with formulas

P

postal vet

Can someone help me to write a formula to change cell background colors based
on a date.
I have created a training spreadsheet to inform me when individuals are due
for training. At my last job, I created the same spreadsheet but now I cannot
remember the formulas I used.
The cells would remain green if training was in toloerance, turn yellow when
training due date was 30 days out and turn red when the due date passed.
I used a nested if function for the dates but can't remember how to change
the colors.
 
S

Sheeloo

Select the range you want to highlight
Use conditional formatting with
FORMULA IS option
Use formula like
($A1-Today)>30
 
P

postal vet

This does not work. Besides, using the conditional formatting only allows me
to use one color. I am trying to use three colors: green, yellow and red.
 
S

Sheeloo

You can have upto three conditions and hence three colors.

What condition are your using?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell color changes when date gets closer 2
Word Globally Changing Specific Color Highlight to Background Color 0
Problem with formulas 4
Conditional Format Based on Date 3
auto colored cells with days 3
Conditional Formatting Using "OR" 3
Cell Color (background & text) Different in Shared Workbooks 1
Date Functions & Formatting 6

Top