Formatting cells in Excel 2010

  Tulips 18:23 20 Feb 2011
Locked

Hi folks, I am trying to formatt a group of cells in one block, A1-A3 across to G1-G3. I want the cell to go pink and bold when the number is 3 and below, any ideas because when I try, all the cells go pink, chhers.

  VoG II 18:28 20 Feb 2011

Hi. Select A1:G3, on the Home tab click Conditional Formatting, click New Rule, click Use a formula and in the box enter

=A1<=3

then click the Format button, apply your format then click OK twice.

  Tulips 21:45 20 Feb 2011

Almost there, I can get the numbers below 3 any colour I want but can't get the cell to change colour?

  VoG II 07:24 21 Feb 2011

In the formatting dialog click on the Fill tab to apply a fill colour.

  Tulips 19:15 21 Feb 2011

I'm so close I can smell it !!! When there is no number in the cell it is filled in (pink) and when I enter a number below 3 it remains pink (which is what I want) and when a number higher than 3 is entered there is no fill (which is also good), how do I make it no fill when there is no number in the cell ?

  VoG II 08:25 22 Feb 2011

=AND(A1<>"",A1<=3)

  Tulips 18:03 22 Feb 2011

Success and it taste's great!!! thanks VoG

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

50 best online Adobe XD tutorials

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?