Previous Topic Next Topic

Conditional Formatting Issue

Solved/Closed
Helln - Jun 16, 2011 at 11:35 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 17, 2011 at 08:05 AM
Hello,

I'm using Excel 2007

I want my cell in F2 to be formatted conditionally to A1 being >250 and <1501, to show up in background green+bold.

By the way A1 is also used for F1 to be <=250 and F3 to be >=1501 to show up green background and bold.

No problem getting conditional format in F1 and F3, but I'm having trouble with F2.

Please help! Thanks in advanced!

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 17, 2011 at 08:05 AM
Hi Helln,

Use this formula:
=AND(A1>250,A1<1501)

Best regards,
Trowa
1

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses