Solved Change Cell color without changing the cell data

Microsoft Excel 2010 (academic)
February 21, 2013 at 06:07:20
Specs: Windows 7
I am looking to change the value in the cell if it meets certain conditions and then the color of the cell if it meets other conditions. ie.... I am tracking the status of some projects. I have dates across the top. If the entered target start date matches the date at the top an "ST" is entered into the cell. If the actual start date matches the date at the top the cell color changes. I cannot use (I think) conditional formating because I don't want to change the cell value. I am thinking something like:

=IF($I7=L$6,"CL",IF($H7=L$6,"ST",IF(AND(L$6>=$J7,L$6<=$K7),Change cell color to green,"")))

H7 is the Target Start date
I7 is the target End Date
J7 is the actual Start date
K7 is the actual end date
L6 is the date I am comparing to



See More: Change Cell color without changing the cell data

Report •

#1
February 21, 2013 at 13:16:31
✔ Best Answer
Conditional Formatting requires only that the formula return TRUE, so

If the actual start date matches the date at the top the cell color changes.

something like: =IF(J7=L6,TRUE,FALSE)

even shorter version: =J7=L6

Conditional Formatting 2007

1) Select your cell or range of cells
2) On the ribbon click Conditional Formatting
3) Click on New Rules, it’s near the bottom of the dialog box.
4) Click Use Formula to determine which cells to format.
5) Enter the formula:

=IF(J7=L6,TRUE,FALSE)

6) Click on the Format button
7) Select the Fill Tab
8) Select a Green color
9) Click OK
10) Click OK

See how that works.

MIKE

http://www.skeptic.com/


Report •

#2
February 21, 2013 at 13:39:36
That Worked!! I have never used Conditional formatting that way. THANKS

Report •
Related Solutions


Ask Question