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!

Conditional Formatting Issue
How to clear formatting in excel - Guide
Excel conditional formatting if another cell contains specific text - Excel Forum
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
Excel formula to change cell color without conditional formatting - Excel Forum
Phone formatting software for pc - Download - File management

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 17, 2011 at 08:05 AM

Hi Helln,

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

Best regards,
Trowa

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

Conditional formating - apply on more cells

one cell will turn green when the two other cells match

Similar discussions

Subscribe To Our Newsletter!