conditional formatting problem

I tried conditional formatting but am doing something wrong.

Please help

Anyway, the spreadsheet attached explains it a bit better

Hello rookie37
I don't think you can make it change front size with con formatting, or not in 2003 anyway.
But I named the cell j46 as "yesno" and made it change the font style in e7, so I don't know if thats any good to you.
Someone with a bit more experiance may know of a way.
Regards
Peter
Obviously I named the copy of sheet1 j46 as yesno, so you would have to change the ref to sheet1 j46 (not the copy)
Regards
Peter

You cannot change font size with conditional formatting.

If you are happy with a macro you could try this in the sheet module for "Sheet1"

Note that you have renamed Sheet2 as "Sheet1". This means that the module you are looking for is
Sheet2(Sheet1)

Please Login or Register  to view this content.

If you don't need the cell coloured then delete these lines

Please Login or Register  to view this content.

Hope ths helps

Thank you Marcol.

I'm embarrassed to say that I don't know how to use it as I have a very limited knowledge of code

I went into sheet 1, ( renamed as EOT tab. If I understood macros I wouldn't get this messy) left click on the tab, selected view code, and copy and pasted your macro on it.
It didn't work. I'm sure I did it wrong.

I don't know what is easier. You could explain it to me how to insert the code properly, or you can make the changes and explain what you did so that I learn.

Hi rookie37

No need to be embarassed, that's what we are here for to help people to learn.

1/. With your workbook select sheet "EOT tab"
2/. Right Click on the sheet tab. Select "View Code"
3/. In the resultant pane paste all of the given code
4/. Save file and exit the Vba editor.

Please note it will depend on the Zoom Level you have chosen how the result will display.

I have attached a version of your workbook as a demo

I doesn't work. However because you said it depends on the zoom level, that may be a problem with my video card. I zoomed in and out with no success but I have always had a problem with my video card.

By the way, I tried to install the code the way you said. I also tried the file that you repaired and sent back to me.

My graphics do weird things. Often, the pictures on my spreadsheets move and increase in size. I then scroll or zoom out or in and they are back to where they should be.

If I am in a word document and typed the text above, it sometimes looks like:

I doesn't work. However because you said it depends on the zoom level, that may be a problem with
I doesn't work. However because you said it depends on the zoom level, that may be a problem with
I doesn't work. However because you said it depends on the zoom level, that may be a problem with
I doesn't work. However because you said it depends on the zoom level, that may be a problem with
I doesn't work. However because you said it depends on the zoom level, that may be a problem with

but then it changes back to normal

I just thought of a way. It is a bit bodgy but I'll do it if we can't think of something else

I want 142.5 but get 143 instead

I can set it up to get 142
AND
if cell e7 = 142 then cell f7 = .5 else blank (I don't want to display a zero)
However I also have to change others and I don't know how to do multiple if then statements

How do I write

if cell e7 = 142 or 52 or 67 or 82 or 97 then cell f7 = .5

If it is easy to do I would also put
if cell e7 = 86 then cell f7 = .25

I've double checked everything and made a change to the formatting code.

With your chosen font this works and displays correctly at zoom levels of 100% and above.

I don't want to widen the column as that will stuff up my calendar

I don't see why it should.

Your problem lies with your column widths, 4pts will only display 4 digits with calibri, you are wanting to display 5.
I would suggest you change all the column widths to 6pts and format E7 Number > "0.0" then there should be no need for any code to change font size.

Select Columns A to AK then Format > Column Width = 6 > OK

if gmt = 5:45, the standard meridian should be 86.25 not 86

If you also need this then format E7 Number > "0.00" and change the column widths accordingly

I have changed the attachment in Post #5 rather than add a new attachment here.

I suggest you look at this link
Description of how column widths are determined in Excel
http://support.microsoft.com/kb/214123

I hope this helps.