ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional Formatting, help? (https://www.excelbanter.com/excel-discussion-misc-queries/84150-conditional-formatting-help.html)

Mariella

Conditional Formatting, help?
 
Hello, I'm trying to conditinally format some cells.
I select them, go to the menu, set the value and press the format button.
But the first table where you set the Font table (the first) is not
highlighted so I can't choose anything there. The frame table seems fine
though. Any suggestions?

Bryan Hessey

Conditional Formatting, help?
 

You should be able to select the Underline, the Normal/Bold, and the
font colour.

Are you sure that these do not work?

--


Mariella Wrote:
Hello, I'm trying to conditinally format some cells.
I select them, go to the menu, set the value and press the format
button.
But the first table where you set the Font table (the first) is not
highlighted so I can't choose anything there. The frame table seems
fine
though. Any suggestions?



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=534446


Mariella

Conditional Formatting, help?
 
Correct, I can select underline and normal/bold but neither font or font size.
I know this can work cause I've done it before?

"Bryan Hessey" wrote:


You should be able to select the Underline, the Normal/Bold, and the
font colour.

Are you sure that these do not work?

--


Mariella Wrote:
Hello, I'm trying to conditinally format some cells.
I select them, go to the menu, set the value and press the format
button.
But the first table where you set the Font table (the first) is not
highlighted so I can't choose anything there. The frame table seems
fine
though. Any suggestions?



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=534446



Bob Phillips

Conditional Formatting, help?
 
Is it a shared workbook?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Mariella" wrote in message
...
Correct, I can select underline and normal/bold but neither font or font

size.
I know this can work cause I've done it before?

"Bryan Hessey" wrote:


You should be able to select the Underline, the Normal/Bold, and the
font colour.

Are you sure that these do not work?

--


Mariella Wrote:
Hello, I'm trying to conditinally format some cells.
I select them, go to the menu, set the value and press the format
button.
But the first table where you set the Font table (the first) is not
highlighted so I can't choose anything there. The frame table seems
fine
though. Any suggestions?



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:

http://www.excelforum.com/member.php...o&userid=21059
View this thread:

http://www.excelforum.com/showthread...hreadid=534446





Bryan Hessey

Conditional Formatting, help?
 

Hi Bob,

Conditional does not work on a Shared, I have Excel 2003 and cannot set
Font nor Font Size in Conditional formatting, but can set Underline,
Bold/Italic, and Font Colour.

Mariella - What version of Excel do you have, and have you upgraded
recently, perhaps this is a feature lost.

--

Bob Phillips Wrote:
Is it a shared workbook?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Mariella" wrote in message
...
Correct, I can select underline and normal/bold but neither font or

font
size.
I know this can work cause I've done it before?

"Bryan Hessey" wrote:


You should be able to select the Underline, the Normal/Bold, and

the
font colour.

Are you sure that these do not work?

--


Mariella Wrote:
Hello, I'm trying to conditinally format some cells.
I select them, go to the menu, set the value and press the

format
button.
But the first table where you set the Font table (the first) is

not
highlighted so I can't choose anything there. The frame table

seems
fine
though. Any suggestions?


--
Bryan Hessey

------------------------------------------------------------------------
Bryan Hessey's Profile:

http://www.excelforum.com/member.php...o&userid=21059
View this thread:

http://www.excelforum.com/showthread...hreadid=534446




--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=534446


Bob Phillips

Conditional Formatting, help?
 
I know, that is why I asked.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bryan Hessey"
wrote in message
...

Hi Bob,

Conditional does not work on a Shared, I have Excel 2003 and cannot set
Font nor Font Size in Conditional formatting, but can set Underline,
Bold/Italic, and Font Colour.

Mariella - What version of Excel do you have, and have you upgraded
recently, perhaps this is a feature lost.

--

Bob Phillips Wrote:
Is it a shared workbook?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Mariella" wrote in message
...
Correct, I can select underline and normal/bold but neither font or

font
size.
I know this can work cause I've done it before?

"Bryan Hessey" wrote:


You should be able to select the Underline, the Normal/Bold, and

the
font colour.

Are you sure that these do not work?

--


Mariella Wrote:
Hello, I'm trying to conditinally format some cells.
I select them, go to the menu, set the value and press the

format
button.
But the first table where you set the Font table (the first) is

not
highlighted so I can't choose anything there. The frame table

seems
fine
though. Any suggestions?


--
Bryan Hessey

------------------------------------------------------------------------
Bryan Hessey's Profile:

http://www.excelforum.com/member.php...o&userid=21059
View this thread:

http://www.excelforum.com/showthread...hreadid=534446




--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:

http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=534446





All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com