View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Change font colour

Yoe are welcome! Thanks for the feedback!
Stefi


€˛Min€¯ ezt Ć*rta:

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!