Change Font Color in cell Based on another cell value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which uses Validation lists. I'm looking to have the font
color, in Specific Cells (say cells B10, H10,I12, etc.), Change to red based
on a value selected from a drop down validation list in cell F4 (Value =
"New").

Any help would be appreciated!
 
This looks like conditional formatting.

select the cells B10,H10, I10
goto CF, Format>Conditional Formatting
Change Condition1 to Formula Is
Add a formula of =$F$4="New"
Pick the Font colour from Format
OK

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Perfect!

Thanks...
--
John


Bob Phillips said:
This looks like conditional formatting.

select the cells B10,H10, I10
goto CF, Format>Conditional Formatting
Change Condition1 to Formula Is
Add a formula of =$F$4="New"
Pick the Font colour from Format
OK

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 
You must log in or register to reply here.

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

Change the font color based on value of cell 1
Change the font color based on the value of the cell 9
Color rows based on a cell value 2
Change cell color 1
Font Color to match other cell 1
making a cell a certain font color based on condition 1
Change cell font color when cell is clicked 9
How to color cells based upon a value in another cell 1

Back
Top