Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

change cell colour in formula

Status
Not open for further replies.
Guthro

Guthro

Technical User
Sep 9, 2006
107
GB
Hello.
Is there a method to change an excel cell colour (or font attribute etc.) based on the result of an expression ?

ie.
=if (A1>0,(A2,color,green))

Thanks
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
320
SkipVought
S
scubafrog79
  • Locked
  • Question
Formula for checking cells for value and then subtract value 1
Replies
8
Views
228
SkipVought
S
ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
188
ladyck3
ladyck3
TomSalvato
  • Locked
  • Question
EXCEL-formula help 2
Replies
6
Views
188
TomSalvato
TomSalvato
pendle666
  • Locked
  • Question
Change colour of cells based on dropdown list value in another - Excel professional plus 2016 1
Replies
5
Views
182
pendle666
pendle666

Part and Inventory Search

Sponsor

Back
Top