| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=IF(D13="PAID","YES","NO") Can I change fonts colour
How do I Change the colour Of "YES" To Blue and "NO" to red
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=IF(D13="PAID","YES","NO") Can I change fonts colour
Look up Conditional Formatting in help, it does that sort of thing.
-- HTH RP (remove nothere from the email address if mailing direct) "Kev" wrote in message ... How do I Change the colour Of "YES" To Blue and "NO" to red |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=IF(D13="PAID","YES","NO") Can I change fonts colour
Conditional Format the cell. Formula is =d13="YES" then under format
change font color. Then add another condition for your no. Here's the link to explain it better. http://www.mvps.org/dmcritchie/excel/condfmt.htm "Kev" wrote: How do I Change the colour Of "YES" To Blue and "NO" to red |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=IF(D13="PAID","YES","NO") Can I change fonts colour
Cell Value is equal To Yes
"Kev" wrote: How do I Change the colour Of "YES" To Blue and "NO" to red |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change cell colour, X no days from inserted date in Excel? | Excel Worksheet Functions | |||
| how do i get cell to change colour when text is added to it to hi. | Excel Discussion (Misc queries) | |||
| Change Sheet Tab Colour | Excel Discussion (Misc queries) | |||
| How do I get traffic lights in excel that change colour | Excel Worksheet Functions | |||
| Macro button colour change??? | Excel Worksheet Functions | |||
Linear Mode
