Change FORMAT

G

Guest

I am just a beginner and I would like to change the format of as cell
according to a condition in another cell.

First example:I have a cell A3 that contains a text, and I want to change it
format to BOLD and change the background to BLUE when A1=M

Second example:I have a cell A3 that contains a text, and I want to change
it format to BOLD and change the background to BLUE when A1 has a GREEN
background

Please help
 
D

Dave Peterson

You're gonna need a User defined function to get the value of a color.

See Chip Pearson's site for a nice version:
http://www.cpearson.com/excel/colors.htm
Look for: Returning The ColorIndex Of A Cell

Then you can use that UDF in the conditional formatting's "formula is" box.
 

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 Color of cell 3
count until blank cell 2
Hotkey for Font color change while editing cell. 4
conditional format cell 3
Change Cell colour on click 5
Conditional formatting in Excel 2010 2
Excel Copy COUNTIF while retaining reference 7
how do have 2 conditional formats for one cell 2

Top