ExcelBanter - Change font colour

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Change font colour (https://www.excelbanter.com/excel-discussion-misc-queries/136356-re-change-font-colour.html)

Stefi

Change font colour

Select column B
Formats/Conditional formatting
Choose formula as criterium
Formula: =B1<A1 set format/pattern/choose pink

Regards,
Stefi

€žMin€ ezt Ã*rta:

I have 2 columns of data.
If the number in b1 is less than a1, I want the number in b1 to be displayed
in pink.
How do I do this?
Many thanks for any help!

Min

Change font colour

Many thanks! Easy when you know how!

"Stefi" wrote:

Select column B
Formats/Conditional formatting
Choose formula as criterium
Formula: =B1<A1 set format/pattern/choose pink

Regards,
Stefi

€žMin€ ezt Ã*rta:

I have 2 columns of data.
If the number in b1 is less than a1, I want the number in b1 to be displayed
in pink.
How do I do this?
Many thanks for any help!

All times are GMT +1. The time now is 08:36 AM.