A1=2^20-999

[James Perry]

If i key in cell A1, =2^20-999, i get a value of 1047577 in cell A1. But i wud like that cell (A 1047577) to get highlighted. So how do i do this? ( I DON'T want to use the name box)

Thank u guys.


Btw....i use a Mac

 

[Hui]

James


Firstly, Welcome to the Chandoo.org Forums


Apply a Custom Cell Format


Select the cells

Right Click, or Ctrl 1, Format Cells

Number Tab

Custom

enter A # or A 0 in the Type: dialog

 

[Marcilio]

Good Morning, Master Hui and James.


I use an Excel 2003 version.

If I want to do a job like James wants, I need to use a Conditional Format.

Selecting all cells I need, putting formula =ROW(A2)=$A$1 and selecting my desired color to highlight the cell.


I misunderstood your explanation James?


Have a nice day to all.


Belo Horizonte, MG - Brazil

Marcílio Lobão